<?php

$vSql = "SELECT m1.nom as nomj1,m1.prenom as prenomj1, m1.pseudo as pseudoj1, m2.nom as nomj2,m2.prenom as prenomj2, m2.pseudo as pseudoj2 , duree, to_char(dateheure, 'YYYY/MM/DD HH24:MI:SS') as dateheure,pointegerj1,pointegerj2,numero 
    from match join membre as m1 on match.j1pseudo = m1.pseudo join membre as m2 on match.j2pseudo = m2.pseudo order by numero DESC";
$vQuery = pg_query($oSql, $vSql);
?>
